dataSource {
	/*
	 * for develop
	 */
//	pooled = true
//	driverClassName = "org.hsqldb.jdbcDriver"
//	username = "sa"
//	password = ""

	/*
	 * for product
	 */
	pooled = false
	driverClassName = "com.mysql.jdbc.Driver"
	username = "root"
	password = ""
}

hibernate {
    cache.use_second_level_cache=true
    cache.use_query_cache=true
    cache.provider_class='com.opensymphony.oscache.hibernate.OSCacheProvider'
}
// environment specific settings
environments {
	development {
		dataSource {
			/*
			 * for develop
			 */
			dbCreate = "create-drop" // one of 'create', 'create-drop','update'
			url = "jdbc:hsqldb:mem:devDB"
			
			/*
			 * for product
			 */
//			dbCreate = "update"
//			url = "jdbc:mysql://localhost/vrs?useUnicode=true&amp;characterEncoding=UTF8"
		}
	}
	test {
		dataSource {
			dbCreate = "update"
			url = "jdbc:hsqldb:mem:testDb"
		}
	}
	production {
		dataSource {
			dbCreate = "update"
			url = "jdbc:hsqldb:file:prodDb;shutdown=true"
		}
	}
}